package com.example.springboot_zc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot_zc.pojo.MyData;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface mydataMapper extends BaseMapper<MyData> {

    @Delete("delete from mydata where stu_num=#{stuNum}")
    public Integer deleteByStu(String stuNum);
    @Select("SELECT class_num AS classNum,stu_num AS stuNum,xx_name AS xxName,content_sm AS contentSm,evi_mat AS eviMat,sug_score AS sugScore,my_self_score AS mySelfScore,my_bw_score AS myBwScore,my_new_time AS myNewTime from mydata where stu_num=#{stuNum}")
    public List<MyData> selectByStu(String stuNum);
}
